﻿using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

public partial class worker1 : System.Web.UI.Page
{
    AccessDAO dao = new AccessDAO(); 

    protected void Page_Load(object sender, EventArgs e)
    {
        string s2 = "select * from billInfo where id=1";
        DataSet ds2 = dao.getDs(s2);
        this.dlProdu.DataSource = ds2;
        this.dlProdu.DataBind();

        int id = Convert.ToInt32(Request.QueryString["id"].ToString());
        string ss = "select * from workMan where id="+id;
        this.work.DataSource = dao.getDs(ss);
        this.work.DataBind();
    }
}
